﻿CREATE TABLE [dbo].[Store_Category] (
    [Id]            INT             IDENTITY (1, 1) NOT NULL,
    [ParentId]      INT             NOT NULL,
    [CreationDate]  DATETIME        CONSTRAINT [DF_Store_Category_CreationDate] DEFAULT (getdate()) NOT NULL,
    [FullImgLink]   NVARCHAR (4000) NULL,
    [SmallImgLink]  NVARCHAR (4000) NULL,
    [SortOrder]     INT             NOT NULL,
    [IsEnabled]     BIT             NOT NULL,
    [ProductsCount] INT             NOT NULL,
    [FriendlyUrl]   NVARCHAR (64)   NOT NULL,
    CONSTRAINT [PK_Store_Category] PRIMARY KEY CLUSTERED ([Id] ASC)
);

